QUALITY REMANUFACTURED CRATE ENGINES SINCE 1975
DOMESTIC FOREIGN REPLACEMENT RESTORATION CUSTOMIZATION
SELECT a.ProductID,a.SSPartNo,a.CoreCharge,d.Description as modelname,b.ModelID,b.SubModelID,b.MakeID,e.Description as enginetype,a.Price,a.ImageFileName,a.SizeLiters,a.SizeCID,b.StartYear,b.EndYear,b.ProductDetailID,c.SubModelCode,f.Description as makename,o.id as oilId,a.transmission,a.trimname,a.notes,a.drivesysytem,a.HDCast FROM products a LEFT JOIN productdetail b ON a.ProductID=b.ProductID LEFT JOIN submodels c ON b.SubModelID=c.SubModelID LEFT Join models d ON d.ModelID = b.ModelID LEFT Join enginetypes e ON a.EngineTypeID = e.EngineTypeID LEFT Join makes f ON f.MakeID = b.MakeID LEFT JOIN oilmanange o ON a.oilId = o.id where b.ProductID = 1171
